package com.clwl.supervise.superviseapp.mapper.base;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Map;

/**
 * 对接大数据同步的数据表用
 */
@Mapper
public interface JgDsjMapper extends BaseMapper<Object> {



    /**
     * 企业列严
     * @return
     */
    Map<String, Object> getLieYanByCreditCode(@Param("creditCode") String creditCode);
    
    int getLieYanByCreditCodeCount(@Param("creditCode") String creditCode);
    
    /**
     * 企业列异
     * @return
     */
    Map<String, Object> getLieYiByCreditCode(@Param("creditCode") String creditCode);
    
    int getLieYiByCreditCodeCount(@Param("creditCode") String creditCode);
    
    /**
     * 企业抽样不合格
     * @return
     */
    Map<String, Object> getChouyangByLicense(@Param("license") String license);
    
    int getChouyangByLicenseCount(@Param("license") String license);

    /**
     * 许可证即将过期
     * @return
     */
    Map<String, Object> getLicenseByCompanyId(@Param("companyId") Long companyId);
    
    int getLicenseByCompanyIdCount(@Param("companyId") Long companyId);
    
}